https://store-images.s-microsoft.com/image/apps.2696.6aee4ed6-625a-4092-8c62-236d4872fa28.7b7c8da4-4e55-4943-80e1-2c0161200a13.c64d3008-c896-44a9-bd00-942cc3ea4ada

Import Data Templates

by MEMENTO SRL

Easily create and use import models for journals and documents from Excel and other formats.

Import Templates for Microsoft Dynamics Business Central


This app is designed to facilitate easy importation of documents and journals into Microsoft Dynamics Business Central through powerful, configurable templates.

Users can quickly import data in its original format without the need for complex data transformations or customizations.

Common use cases for imports include:
  • Vendor purchase invoices.
  • Customer sales invoices.
  • Allocation journals.
  • Payroll journals.
and so on...

Import

  1. The import process can be initiated directly from the specific journal or document page.
  2. Excel, CSV and fixed-length files are supported.
  3. The most common types of Business Central entries are covered:
    • Documents: Sales Quotes, Sales Orders, Sales Return Orders, Sales Invoices, Sales Credit Memos, Purchase Quotes, Purchase Orders, Purchase Return Orders, Purchase Invoices, Purchase Credit Memos, Transfer Orders, Assembly Orders and more.
    • Journals: General Journals, Payment Journal, Cashs, Cash Receipts Journals, Sales Journals, Purchase Journals, Job Journals, Job G/L Journals, Fixed Asset Journals, Fixed Asset G/L Journals, Resource Journals, Item Journals, Item Reclassification Journals and more.
4. Import single files or multiple files within a ZIP archive.
5. Use mapping rules to map external data to Business Central entities.
6. Providing specific parameters during the import process for variable data, such as selecting the posting date.
7. Automatically apply processing actions to the imported data, such as releasing documents or posting journals.

Management

  1. The list of imported files can be saved, also preventing duplicate imports.
  2. Templates can be made available only to specific users.
  3. Import, export and copy existing templates.
  4. Create templates based on example files or export the template structure to be filled with data.

Automation

  1. API integration is available to automate the import process from external systems or through Power Automate.

Supported countries

The app is available in the following countries:
Armenia, Australia, Austria, Barbados, Belarus, Bulgaria, Belgium, Cambodia, Canada, Chile, Colombia, Croatia, Cyprus, Czechia, Denmark, Egypt, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, India, Indonesia, Ireland, Italy, Kenya, Latvia, Liechtenstein, Lithuania, Luxembourg, Malaysia, Malta, Monaco, Netherlands, New Zealand, Nigeria, Norway, Poland, Portugal, Romania, Russia, Saudi Arabia, Serbia, Singapore, Slovakia, Slovenia, South Africa, South Korea, Spain, Sweden, Switzerland, Taiwan, Thailand, Türkiye, United Arab Emirates, United Kingdom, United States, Vietnam.

Supported languages

The app is available in English and Italian.

At a glance

https://store-images.s-microsoft.com/image/apps.48687.6aee4ed6-625a-4092-8c62-236d4872fa28.7b7c8da4-4e55-4943-80e1-2c0161200a13.afb888fa-606c-4113-9965-96d042b8c816
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.48687.6aee4ed6-625a-4092-8c62-236d4872fa28.7b7c8da4-4e55-4943-80e1-2c0161200a13.afb888fa-606c-4113-9965-96d042b8c816
https://store-images.s-microsoft.com/image/apps.27662.6aee4ed6-625a-4092-8c62-236d4872fa28.7b7c8da4-4e55-4943-80e1-2c0161200a13.3028f324-4eb3-4bf5-a21f-60df4cb69070
https://store-images.s-microsoft.com/image/apps.48.6aee4ed6-625a-4092-8c62-236d4872fa28.7b7c8da4-4e55-4943-80e1-2c0161200a13.c65bff60-2b08-4f41-b818-9d077fd76451
https://store-images.s-microsoft.com/image/apps.39268.6aee4ed6-625a-4092-8c62-236d4872fa28.7b7c8da4-4e55-4943-80e1-2c0161200a13.5d1d0adb-28be-4532-a14c-9ffd1d31d8af
https://store-images.s-microsoft.com/image/apps.10860.6aee4ed6-625a-4092-8c62-236d4872fa28.7b7c8da4-4e55-4943-80e1-2c0161200a13.1f3e0d76-774d-4eec-860c-5fc80292c5cb